var sqlMap = {
  /***用户****/
  user: {
    ADD_I: 'insert into user(username,password) values(?,?)', // 新增用户
    SELECT_S: 'SELECT * FROM user',
    USERINFO_S: 'SELECT * FROM user WHERE username=?', // 用户是否存在
    USERPWD_S: 'SELECT * FROM user WHERE username=? and password=?', // 用户名和密码是否匹配
    USER_D: 'DELETE  FROM user WHERE id=?', // 删除用户
  },
  /***菜单****/
  menu: {
    SELECT_S: 'SELECT * FROM menu',
  },
  /***文章管理****/
  article: {
    SELECT: 'SELECT * FROM article',
    ADD: 'insert into article(title,content,createTime) values(?,?,?)', // 新增用户
    UPDATE: 'UPDATE article SET title=?, content=? , createTime=? WHERE id=?', // 新增用户
    DEL: 'DELETE  FROM article WHERE id=?', // 删除用户
  },
};

module.exports = sqlMap;
